﻿CREATE TABLE [dim].[Date] (
    [DateId]                INT          NOT NULL,
    [ReportingDateId]       INT          NOT NULL,
    [Date]                  DATETIME     NOT NULL,
    [DateName]              VARCHAR (20) NOT NULL,
    [WeekId]                INT          NOT NULL,
    [WeekName]              VARCHAR (20) NOT NULL,
    [WeekDate]              DATETIME     NOT NULL,
    [MonthId]               INT          NOT NULL,
    [MonthName]             VARCHAR (20) NOT NULL,
    [QuarterId]             INT          NOT NULL,
    [QuarterName]           VARCHAR (20) NOT NULL,
    [HalfYearId]            INT          NOT NULL,
    [HalfYearName]          VARCHAR (20) NOT NULL,
    [YearId]                INT          NOT NULL,
    [YearName]              VARCHAR (20) NOT NULL,
    [FinancialQuarterId]    INT          NOT NULL,
    [FinancialQuarterName]  VARCHAR (20) NOT NULL,
    [FinancialHalfYearId]   INT          NOT NULL,
    [FinancialHalfYearName] VARCHAR (20) NOT NULL,
    [FinancialYearId]       INT          NOT NULL,
    [FinancialYearName]     VARCHAR (20) NOT NULL,
    [RowChecksumMD5]        CHAR (36)    NOT NULL,
    [RowAuditId]            INT          NOT NULL,
    PRIMARY KEY CLUSTERED ([DateId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

